<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <%@ page import="java.sql.*" %>
<html>
  <head>
  <%!
ResultSet rs1=null;
Connection con=null;

 %>
   
	  <body bgcolor="#fffff0">
  	<img src="images/14.jpeg" height=300 width=1200 />
  	<%
   try
   {
     	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","bank","bank");
		Statement st=con.createStatement();
		rs1=st.executeQuery("select address from checkbook");
	}
	catch(Exception e)
	{
	System.out.println(e);
	}
%>
 <form method="get" action="checkbook.jsp">
 <select name="address" style="position:absolute;left:573px;top:373px;width:200px;z-index:2">
 <%
while(rs1.next())
{%>
 <option>
   <%=rs1.getString(1)%>
 </option>
 <%
 }
%>
</select>
<input name="formbutton1" type="submit" value="Submit" style="position:absolute;left:607px;top:427px;z-index:3">
</form>

<div id="text1" style="position:absolute; overflow:hidden; left:499px; top:374px; width:63px; height:27px; z-index:1">
<div class="wpmd">
<div><font color="#FF0000" class="ws14">Address<br></font></div>
</div></div>

</body>
</html>